Scenario

Little Lemon needs to build a robust relational database system in MySQL to store large amounts of data which they can also easily manage and locate as required. Little Lemon have decided to use MySQL Workbench to develop their new database system. They need you to help them set up their MySQL environment to prepare for the design and development of their database.

Prerequisites

MySQL Workbench must already be downloaded and installed on your machine.

Task Instructions

Complete the following tasks to help Little Lemon set up their MySQL environment.

Task 1

Creating a new user is the most secure way to connect to your MySQL database. In this first task, you need to use MySQL Workbench to create a new user account.

Here is some guidance for completing this task:

Task 2

To prepare for building and managing your database, you need to be connected to a MySQL server. In this task you need to create a new MySQL connection.

Here is some guidance for completing this task:

Once you have completed this task, you can use this connection to begin working with database schemas and SQL queries.

Conclusion

In this exercise, you created a new user account and an instance server. You are now ready to develop a suitable database system for Little Lemon.